Associating Reference Tables with Mappings

Reference data sets the permissible values for other data fields. To standardize your data, you can associate a reference table with mappings. Ensure that you publish the required reference table before associating it with mappings.

To associate reference tables with Mappings, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, click a map.

    3. The Mapping Specification grid appears.

    Mapping Specification Grid Reference Table
  3. Click Icon Edit.
  4. Right-click the header menu.
    5. Reference Table Column Mapping Specification
  5. Select the Reference Table check box.

    6. The Reference Table column appears in the Mapping Specification grid.

  6. Drag the reference table from Reference Table Catalog and drop it on the required row under the Reference Table column.

    7. You can associate multiple source columns with the reference tables.

    Drag Drop Csm
  7. Click Icon Save Mapping Specification.

    8. The reference table is associated with the mappings.